                SELECT ConfigItem, EnvironmentID, ConfigValue From 
                                dbo.dsicfgConfiguration
                                 WHERE (ApplicationName = 'REPORTING') AND (ServerName = '*SYSTEM') AND
                                 (ConfigItem LIKE 'PARAMETERS-%')
                                 ORDER BY ConfigItem, EnvironmentID

SELECT     ConfigItem, EnvironmentID, ConfigValue
FROM         dsicfgConfiguration
WHERE     (ApplicationName = 'REPORTING') AND (ServerName = '*SYSTEM') AND (ConfigItem LIKE 'PARAMETERS-%')
ORDER BY ConfigItem, EnvironmentID
